Opening a Unicode CSV file
We are an international company. How do I open a document with foreign characters?
A Unicide CSV file with foreign or double byte characters, can be saved to a local hard disk. To import a Unicide CSV file in Microsoft Excel:
- Save the CSV file locally.
- Open Microsoft Excel.
- Select the Data tab.
- Click From Text.
- Browse to and select the CSV file to open.
-
Click Import.
The Text Import Wizard opens.
-
Verify that the file type is Delimited and the File origin is 65001 : Unicode (UTF-8).
- Click Next.
- In the Delimiter field, select Comma and verify that no other delimited is selected.
- Click Finish.
- Click OK.